create or replace
TRIGGER UNIT_TRIGGER
BEFORE INSERT ON UNIT
FOR EACH ROW WHEN (NEW.UNIT_ID IS NULL)
BEGIN 
	SELECT UNIT_SEQ.NEXTVAL 
	INTO :NEW.UNIT_ID 
	FROM DUAL;
END;